package com.saas.sql;

public class InfoListQuery
{
  public static String infolist_INS_INFO_LIST_BY_ALL = "insert into infolist(infotype,infotitle,infocontent,rece_user,rece_time,send_user,send_time,ifread) values(:VINFOTYPE,:VINFOTITLE,:VINFOCONTENT,:VRECE_USER,now(),:VSEND_USER,now(),0)";
  public static String infolist_GET_All_INFO_LIST = "select i.*,u.user_name,u.cust_name from infolist i,user_info u where i.send_user = u.user_id and (i.rece_user = :VRECE_USER or i.send_user = :VSEND_USER) order by send_time desc";
  public static String infolist_DELETE_READ_INFO_LIST_BY_ALL = "delete from infolist  where paylist_id = :VPAYLIST_ID";
  public static String infolist_UPDATE_READ_INFO_LIST_BY_ALL = "update infolist set ifread = 1 where paylist_id = :VPAYLIST_ID";
  public static String infolist_GET_ONE_INFO_LIST = "select * from infolist where paylist_id = :VPAYLIST_ID";
}

